﻿/* dk2Repository - Copyright (C) 2011 Daniel Kuczewski http://www.dk2.de/

 * This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA */

using System;
using System.Text;

namespace dk2Repository.QueryBuilder.MySql
{
    internal class MySqlBuilder : ISqlBuilder
    {
        public virtual SelectBuilder CreateSelectBuilder()
        {
            return new MySqlSelectBuilder(this);
        }

        public virtual UpdateBuilder CreateUpdateBuilder()
        {
            return new MySqlUpdateBuilder(this);
        }

        public virtual InsertBuilder CreateInsertBuilder()
        {
            return new MySqlInsertBuilder(this);
        }

        public virtual DeleteBuilder CreateDeleteBuilder()
        {
            return new MySqlDeleteBuilder(this);
        }

        public virtual CreateTableBuilder CreateCreateTableBuilder()
        {
            return new MySqlCreateTableBuilder();
        }

        public virtual WhereBuilder CreateWhereBuilder()
        {
            return new MySqlWhereBuilder(this);
        }

        public string CreateSelectColumnString(string column, string alias)
        {
            var sb = new StringBuilder();
            sb.Append(column);
            if(!string.IsNullOrEmpty(alias))
                sb.Append(" ").Append(alias);

            return sb.ToString();
        
        }

        public string CreateOrderString(string column, EnumOrderMethod orderMethod)
        {
            var sb = new StringBuilder();
            sb.Append(column).Append(" ").Append(orderMethod.GetEnumDescription());
            return sb.ToString();
        }

        public string CreateWhereString(string column, EnumCompareMode compareMode, string parametername)
        {
            var sb = new StringBuilder();
            sb.Append(column).Append(compareMode.GetEnumDescription()).Append(string.IsNullOrEmpty(parametername) ? "?" : "@" + parametername).Append(parametername);
            return sb.ToString();
        }

        public string CreateJoinString(EnumJoinMode joinmode, string lefttable, string righttable, string leftcol, string rightcol)
        {
            var sb = new StringBuilder();

            if (joinmode == EnumJoinMode.Inner)
                sb.Append("INNER JOIN");
            else if (joinmode == EnumJoinMode.LeftOuter)
                sb.Append("LEFT OUTER JOIN");
            else if (joinmode == EnumJoinMode.RightOuter)
                sb.Append("RIGHT OUTER JOIN");

            sb.Append(" ").Append(righttable).Append(" ON ").Append(lefttable).Append(".").Append(leftcol).Append(" = ").Append(righttable).Append(".").Append(rightcol);
            return sb.ToString();
        }


    }
}
